
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspFileAttach_UPDATE]
(
@attachId int = null,
@templateId int = null,
@siteContentId int = null,
@eventId int = null,
@documentName nvarchar(250) = null,
@documentType nvarchar(100) = null,
@documentSize int = null,
@isDeleted bit = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[FileAttach]
SET
  [TemplateId] = @templateId,
  [SiteContentId] = @siteContentId,
  [EventId] = @eventId,
  [DocumentName] = @documentName,
  [DocumentType] = @documentType,
  [DocumentSize] = @documentSize,
  [IsDeleted] = @isDeleted,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [AttachId] = @attachId

GO
